package com.fowo.api.model.tmp.storage.fee.month;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 月仓储费临时表 导入导出辅助模型 */
@Getter
@Setter
public class TmpStorageFeeMonthExcelPo {

  @ExcelProperty(value = "店铺id")
  private Long sid;

  @Size(max = 50, message = "ASIN长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "ASIN")
  private String asin;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnsku;

  @Size(max = 5000, message = "标题长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "标题")
  private String productName;

  @Size(max = 50, message = "仓库编号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "仓库编号")
  private String fulfillmentCenter;

  @Size(max = 50, message = "国家代码长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "国家代码")
  private String countryCode;

  @Size(max = 50, message = "长边长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "长边")
  private String longestSide;

  @Size(max = 50, message = "中间边长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "中间边")
  private String medianSide;

  @Size(max = 50, message = "短边长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "短边")
  private String shortestSide;

  @Size(max = 50, message = "长中短边单位长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "长中短边单位")
  private String measurementUnits;

  @Size(max = 50, message = "重量长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "重量")
  private String weight;

  @Size(max = 50, message = "重量单位长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "重量单位")
  private String weightUnits;

  @Size(max = 50, message = "体积长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "体积")
  private String itemVolume;

  @Size(max = 50, message = "体积单位长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "体积单位")
  private String volumeUnits;

  @Size(max = 50, message = "产品标准长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "产品标准")
  private String productSizeTier;

  @Size(max = 50, message = "库存量长度不能超过20")
  @ExcelProperty(value = "库存量")
  private java.math.BigDecimal averageQuantityOnHand;

  @Size(max = 50, message = "待移除量长度不能超过20")
  @ExcelProperty(value = "待移除量")
  private java.math.BigDecimal averageQuantityPendingRemoval;

  @Size(max = 50, message = "总体积长度不能超过20")
  @ExcelProperty(value = "总体积")
  private java.math.BigDecimal estimatedTotalItemVolume;

  @Size(max = 50, message = "收费月份长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "收费月份")
  private String monthOfCharge;

  @Size(max = 50, message = "收费标准长度不能超过20")
  @ExcelProperty(value = "收费标准")
  private java.math.BigDecimal storageRate;

  @Size(max = 50, message = "币种长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "币种")
  private String currency;

  @Size(max = 50, message = "预估仓储费长度不能超过20")
  @ExcelProperty(value = "预估仓储费")
  private java.math.BigDecimal estimatedMonthlyStorageFee;

  @Size(max = 50, message = "危险品存放类型长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "危险品存放类型")
  private String dangerousGoodsStorageType;

  @Size(max = 50, message = "可享受存货折扣长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "可享受存货折扣")
  private String eligibleForInventoryDiscount;

  @Size(max = 50, message = "可享受库存折扣长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "可享受库存折扣")
  private String qualifiesForInventoryDiscount;

  @Size(max = 50, message = "折扣总额长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "折扣总额")
  private String totalIncentiveFeeAmount;

  @Size(max = 50, message = "分项激励金额长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "分项激励金额")
  private String breakdownIncentiveFeeAmount;

  @Size(max = 50, message = "客户订单平均数量长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "客户订单平均数量")
  private String averageQuantityCustomerOrders;

  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> img;

  @Size(max = 5000, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String name;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @ExcelProperty(value = "国家")
  private Long country;
}
